package com.base.po.voip;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class WithdrawalsQueryExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WithdrawalsQueryExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterionForJDBCDate("CreateTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterionForJDBCDate("CreateTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterionForJDBCDate("CreateTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("CreateTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CreateTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CreateTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andVerifyidIsNull() {
            addCriterion("VerifyID is null");
            return (Criteria) this;
        }

        public Criteria andVerifyidIsNotNull() {
            addCriterion("VerifyID is not null");
            return (Criteria) this;
        }

        public Criteria andVerifyidEqualTo(String value) {
            addCriterion("VerifyID =", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidNotEqualTo(String value) {
            addCriterion("VerifyID <>", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidGreaterThan(String value) {
            addCriterion("VerifyID >", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidGreaterThanOrEqualTo(String value) {
            addCriterion("VerifyID >=", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidLessThan(String value) {
            addCriterion("VerifyID <", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidLessThanOrEqualTo(String value) {
            addCriterion("VerifyID <=", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidLike(String value) {
            addCriterion("VerifyID like", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidNotLike(String value) {
            addCriterion("VerifyID not like", value, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidIn(List<String> values) {
            addCriterion("VerifyID in", values, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidNotIn(List<String> values) {
            addCriterion("VerifyID not in", values, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidBetween(String value1, String value2) {
            addCriterion("VerifyID between", value1, value2, "verifyid");
            return (Criteria) this;
        }

        public Criteria andVerifyidNotBetween(String value1, String value2) {
            addCriterion("VerifyID not between", value1, value2, "verifyid");
            return (Criteria) this;
        }

        public Criteria andNoorderIsNull() {
            addCriterion("NoOrder is null");
            return (Criteria) this;
        }

        public Criteria andNoorderIsNotNull() {
            addCriterion("NoOrder is not null");
            return (Criteria) this;
        }

        public Criteria andNoorderEqualTo(String value) {
            addCriterion("NoOrder =", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderNotEqualTo(String value) {
            addCriterion("NoOrder <>", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderGreaterThan(String value) {
            addCriterion("NoOrder >", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderGreaterThanOrEqualTo(String value) {
            addCriterion("NoOrder >=", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderLessThan(String value) {
            addCriterion("NoOrder <", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderLessThanOrEqualTo(String value) {
            addCriterion("NoOrder <=", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderLike(String value) {
            addCriterion("NoOrder like", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderNotLike(String value) {
            addCriterion("NoOrder not like", value, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderIn(List<String> values) {
            addCriterion("NoOrder in", values, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderNotIn(List<String> values) {
            addCriterion("NoOrder not in", values, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderBetween(String value1, String value2) {
            addCriterion("NoOrder between", value1, value2, "noorder");
            return (Criteria) this;
        }

        public Criteria andNoorderNotBetween(String value1, String value2) {
            addCriterion("NoOrder not between", value1, value2, "noorder");
            return (Criteria) this;
        }

        public Criteria andDtorderIsNull() {
            addCriterion("DtOrder is null");
            return (Criteria) this;
        }

        public Criteria andDtorderIsNotNull() {
            addCriterion("DtOrder is not null");
            return (Criteria) this;
        }

        public Criteria andDtorderEqualTo(Date value) {
            addCriterion("DtOrder =", value, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderNotEqualTo(Date value) {
            addCriterion("DtOrder <>", value, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderGreaterThan(Date value) {
            addCriterion("DtOrder >", value, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderGreaterThanOrEqualTo(Date value) {
            addCriterion("DtOrder >=", value, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderLessThan(Date value) {
            addCriterion("DtOrder <", value, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderLessThanOrEqualTo(Date value) {
            addCriterion("DtOrder <=", value, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderIn(List<Date> values) {
            addCriterion("DtOrder in", values, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderNotIn(List<Date> values) {
            addCriterion("DtOrder not in", values, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderBetween(Date value1, Date value2) {
            addCriterion("DtOrder between", value1, value2, "dtorder");
            return (Criteria) this;
        }

        public Criteria andDtorderNotBetween(Date value1, Date value2) {
            addCriterion("DtOrder not between", value1, value2, "dtorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderIsNull() {
            addCriterion("MoneyOrder is null");
            return (Criteria) this;
        }

        public Criteria andMoneyorderIsNotNull() {
            addCriterion("MoneyOrder is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyorderEqualTo(String value) {
            addCriterion("MoneyOrder =", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderNotEqualTo(String value) {
            addCriterion("MoneyOrder <>", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderGreaterThan(String value) {
            addCriterion("MoneyOrder >", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderGreaterThanOrEqualTo(String value) {
            addCriterion("MoneyOrder >=", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderLessThan(String value) {
            addCriterion("MoneyOrder <", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderLessThanOrEqualTo(String value) {
            addCriterion("MoneyOrder <=", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderLike(String value) {
            addCriterion("MoneyOrder like", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderNotLike(String value) {
            addCriterion("MoneyOrder not like", value, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderIn(List<String> values) {
            addCriterion("MoneyOrder in", values, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderNotIn(List<String> values) {
            addCriterion("MoneyOrder not in", values, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderBetween(String value1, String value2) {
            addCriterion("MoneyOrder between", value1, value2, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andMoneyorderNotBetween(String value1, String value2) {
            addCriterion("MoneyOrder not between", value1, value2, "moneyorder");
            return (Criteria) this;
        }

        public Criteria andResultpayIsNull() {
            addCriterion("ResultPay is null");
            return (Criteria) this;
        }

        public Criteria andResultpayIsNotNull() {
            addCriterion("ResultPay is not null");
            return (Criteria) this;
        }

        public Criteria andResultpayEqualTo(String value) {
            addCriterion("ResultPay =", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayNotEqualTo(String value) {
            addCriterion("ResultPay <>", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayGreaterThan(String value) {
            addCriterion("ResultPay >", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayGreaterThanOrEqualTo(String value) {
            addCriterion("ResultPay >=", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayLessThan(String value) {
            addCriterion("ResultPay <", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayLessThanOrEqualTo(String value) {
            addCriterion("ResultPay <=", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayLike(String value) {
            addCriterion("ResultPay like", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayNotLike(String value) {
            addCriterion("ResultPay not like", value, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayIn(List<String> values) {
            addCriterion("ResultPay in", values, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayNotIn(List<String> values) {
            addCriterion("ResultPay not in", values, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayBetween(String value1, String value2) {
            addCriterion("ResultPay between", value1, value2, "resultpay");
            return (Criteria) this;
        }

        public Criteria andResultpayNotBetween(String value1, String value2) {
            addCriterion("ResultPay not between", value1, value2, "resultpay");
            return (Criteria) this;
        }

        public Criteria andOidpaybillIsNull() {
            addCriterion("OidPaybill is null");
            return (Criteria) this;
        }

        public Criteria andOidpaybillIsNotNull() {
            addCriterion("OidPaybill is not null");
            return (Criteria) this;
        }

        public Criteria andOidpaybillEqualTo(String value) {
            addCriterion("OidPaybill =", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillNotEqualTo(String value) {
            addCriterion("OidPaybill <>", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillGreaterThan(String value) {
            addCriterion("OidPaybill >", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillGreaterThanOrEqualTo(String value) {
            addCriterion("OidPaybill >=", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillLessThan(String value) {
            addCriterion("OidPaybill <", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillLessThanOrEqualTo(String value) {
            addCriterion("OidPaybill <=", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillLike(String value) {
            addCriterion("OidPaybill like", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillNotLike(String value) {
            addCriterion("OidPaybill not like", value, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillIn(List<String> values) {
            addCriterion("OidPaybill in", values, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillNotIn(List<String> values) {
            addCriterion("OidPaybill not in", values, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillBetween(String value1, String value2) {
            addCriterion("OidPaybill between", value1, value2, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andOidpaybillNotBetween(String value1, String value2) {
            addCriterion("OidPaybill not between", value1, value2, "oidpaybill");
            return (Criteria) this;
        }

        public Criteria andInfoorderIsNull() {
            addCriterion("InfoOrder is null");
            return (Criteria) this;
        }

        public Criteria andInfoorderIsNotNull() {
            addCriterion("InfoOrder is not null");
            return (Criteria) this;
        }

        public Criteria andInfoorderEqualTo(String value) {
            addCriterion("InfoOrder =", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderNotEqualTo(String value) {
            addCriterion("InfoOrder <>", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderGreaterThan(String value) {
            addCriterion("InfoOrder >", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderGreaterThanOrEqualTo(String value) {
            addCriterion("InfoOrder >=", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderLessThan(String value) {
            addCriterion("InfoOrder <", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderLessThanOrEqualTo(String value) {
            addCriterion("InfoOrder <=", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderLike(String value) {
            addCriterion("InfoOrder like", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderNotLike(String value) {
            addCriterion("InfoOrder not like", value, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderIn(List<String> values) {
            addCriterion("InfoOrder in", values, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderNotIn(List<String> values) {
            addCriterion("InfoOrder not in", values, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderBetween(String value1, String value2) {
            addCriterion("InfoOrder between", value1, value2, "infoorder");
            return (Criteria) this;
        }

        public Criteria andInfoorderNotBetween(String value1, String value2) {
            addCriterion("InfoOrder not between", value1, value2, "infoorder");
            return (Criteria) this;
        }

        public Criteria andSettledateIsNull() {
            addCriterion("SettleDate is null");
            return (Criteria) this;
        }

        public Criteria andSettledateIsNotNull() {
            addCriterion("SettleDate is not null");
            return (Criteria) this;
        }

        public Criteria andSettledateEqualTo(Date value) {
            addCriterion("SettleDate =", value, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateNotEqualTo(Date value) {
            addCriterion("SettleDate <>", value, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateGreaterThan(Date value) {
            addCriterion("SettleDate >", value, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateGreaterThanOrEqualTo(Date value) {
            addCriterion("SettleDate >=", value, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateLessThan(Date value) {
            addCriterion("SettleDate <", value, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateLessThanOrEqualTo(Date value) {
            addCriterion("SettleDate <=", value, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateIn(List<Date> values) {
            addCriterion("SettleDate in", values, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateNotIn(List<Date> values) {
            addCriterion("SettleDate not in", values, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateBetween(Date value1, Date value2) {
            addCriterion("SettleDate between", value1, value2, "settledate");
            return (Criteria) this;
        }

        public Criteria andSettledateNotBetween(Date value1, Date value2) {
            addCriterion("SettleDate not between", value1, value2, "settledate");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("Memo is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("Memo is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("Memo =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("Memo <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("Memo >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("Memo >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("Memo <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("Memo <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("Memo like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("Memo not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("Memo in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("Memo not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("Memo between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("Memo not between", value1, value2, "memo");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}